from openpyxl import load_workbook

def read_excel(file_path,sheet_name):
    wb = load_workbook(file_path, read_only=True)
    ws=wb[sheet_name]
    headers=[cell.value for cell in ws[1]]
    data_list=[]
    for row in ws .iter_rows(min_row=2,values_only=True):
        row=dict(zip(headers,row))
        data_list.append(row)
    wb.close()
    return data_list